IF exists(SELECT * FROM dbo.sysobjects WHERE name='WEB_klassenEnWeg' AND xtype='P') 
BEGIN
	DROP PROCEDURE WEB_klassenEnWeg
END
GO

create procedure WEB_klassenEnWeg
as
set nocount on

select '0AAAA' as klas,'<?xml version="1.0"  encoding="ISO-8859-1" ?><klassen>' as tekst
union
select klas,'<klas>' + isNull(klas,'') + '</klas>'
from vertaalTabelKlas
union
select 'ZZZZZ','</klassen>'
order by klas